package com.mrobuy.jdvc.entity;

import com.gavel.annotation.FieldMeta;
import com.gavel.annotation.TableMeta;

import java.util.Date;

import static com.gavel.database.SQLExecutor.createTable;

@TableMeta(name = "VC_SHELVES_ITEM", title = "JD上架商品")
public class VCShelvesItem {

    @FieldMeta(name = "ID", title = "ID", length = 32, primary = true)
    private String id;

    @FieldMeta(name = "CODE", title = "编码", length = 64)
    private String code;

    @FieldMeta(name = "TASKID", title = "任务ID", length = 50)
    private String taskid;

    @FieldMeta(name = "PRODUCTCODE", title = "商品编码", length = 50)
    private String productcode;

    @FieldMeta(name = "PRODUCTNAME", title = "商品名称", length = 128)
    private String productname;

    @FieldMeta(name = "JDPRODUCTNAME", title = "JD商品名称", length = 128)
    private String jdproductname;

    @FieldMeta(name = "SKUCODE", title = "SKU编码", length = 50)
    private String skucode;

    @FieldMeta(name = "SKUNAME", title = "SKU名称", length = 128)
    private String skuname;

    @FieldMeta(name = "JDSKUNAME", title = "JDSKU名称", length = 128)
    private String jdskuname;

    @FieldMeta(name = "MODEL", title = "制造商型号", length = 20)
    private String model;

    @FieldMeta(name = "PRICE", title = "原价", length = 20)
    private String price;

    @FieldMeta(name = "DELIVERYDATE", title = "发货日期", length = 30)
    private String deliverydate;

    @FieldMeta(name = "UNIT", title = "销售单位", length = 20)
    private String unit;

    @FieldMeta(name = "ZT", title = "状态", length = 20)
    private String zt;

    @FieldMeta(name = "TYPE", title = "类型", length = 8)
    private String type;

    @FieldMeta(name = "BRAND", title = "品牌", length = 50)
    private String brand;

    @FieldMeta(name = "BRANDEN", title = "英文品牌", length = 50)
    private String branden;

    @FieldMeta(name = "CATE1", title = "1级类目", length = 60)
    private String cate1;

    @FieldMeta(name = "CATE2", title = "2级类目", length = 60)
    private String cate2;

    @FieldMeta(name = "CATE3", title = "3级类目", length = 60)
    private String cate3;

    @FieldMeta(name = "CATE4", title = "4级类目", length = 60)
    private String cate4;

    @FieldMeta(name = "ATTRS", title = "属性", length = 15000)
    private String attrs;

    @FieldMeta(name = "ENABLE", title = "是否上架", length = 20)
    private String enable;

    // JD 上架属性
    @FieldMeta(name = "CID1", title = "第一分类ID(三级分类)", length = 20)
    private String cid1;

    @FieldMeta(name = "CIDNAME1", title = "第一分类名称", length = 20)
    private String cidName1;

    @FieldMeta(name = "BRANDID", title = "品牌ID", length = 20)
    private String brandid;

    @FieldMeta(name = "BRANDNAME", title = "品牌名称", length = 20)
    private String brandName;

    @FieldMeta(name = "MARKETPRICE", title = "市场价", length = 20)
    private String marketPrice; // 	900	市场价（小数点后保留2位）

    @FieldMeta(name = "PURCHASEPRICE", title = "采购价", length = 20)
    private String purchasePrice; // 700	采购价（小数点后保留2位）

    @FieldMeta(name = "MEMBERPRICE", title = "京东价(", length = 20)
    private String memberPrice; // 700	800	京东价(（小数点后保留2位）

    @FieldMeta(name = "WEIGHT", title = "商品重量", length = 20)
    private String weight; // 	1.123	商品重量(单位：千克，含包装)小数点后保留3位

    @FieldMeta(name = "LENGTH", title = "长度", length = 20)
    private String length; // 	1.123	长度(单位：毫米，含包装)

    @FieldMeta(name = "WIDTH", title = "宽度", length = 20)
    private String width; // 	1.123	宽度(单位：毫米，含包装)

    @FieldMeta(name = "HEIGHT", title = "高度", length = 20)
    private String height; // 	1.123	高度(单位：毫米，含包装)

    @FieldMeta(name = "ITEMNUM", title = "货号", length = 20)
    private String itemNum; // 132 货号（货号不能包括中文，只能为英文或数字）

    @FieldMeta(name = "ORIGINALPLACE", title = "产地", length = 50)
    private String originalPlace;

    @FieldMeta(name = "WARRANTY", title = "质保期", length = 20)
    private String warranty;

    @FieldMeta(name = "DIM1VAL", title = "第一维度的销售属性值", length = 100)
    private String dim1Val;

    @FieldMeta(name = "DIM1SORT", title = "第一维度销售属性顺序", length = 8)
    private String dim1Sort;

    @FieldMeta(name = "DIM2VAL", title = "第二维度的销售属性值", length = 100)
    private String dim2Val;

    @FieldMeta(name = "DIM2SORT", title = "第二维度销售属性顺序", length = 8)
    private String dim2Sort;

    @FieldMeta(name = "PUSHTIME", title = "上架时间")
    private Date pushtime;

    @FieldMeta(name = "MESSAGE", title = "消息", length = 5000)
    private String message;

    @FieldMeta(name = "APPLYID", title = "申请编码", length = 64)
    private String applyid;

    public VCShelvesItem() {
    }

    public String getJdproductname() {
        return jdproductname;
    }

    public void setJdproductname(String jdproductname) {
        this.jdproductname = jdproductname;
    }

    public String getJdskuname() {
        return jdskuname;
    }

    public void setJdskuname(String jdskuname) {
        this.jdskuname = jdskuname;
    }

    public VCShelvesItem(String id) {
        this.id = id;
    }


    public String getCode() {
        return code;
    }

    public void setCode(String code) {
        this.code = code;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getTaskid() {
        return taskid;
    }

    public void setTaskid(String taskid) {
        this.taskid = taskid;
    }

    public String getProductcode() {
        return productcode;
    }

    public void setProductcode(String productcode) {
        this.productcode = productcode;
    }

    public String getProductname() {
        return productname;
    }

    public void setProductname(String productname) {
        this.productname = productname;
    }

    public String getSkucode() {
        return skucode;
    }

    public void setSkucode(String skucode) {
        this.skucode = skucode;
    }

    public String getSkuname() {
        return skuname;
    }

    public void setSkuname(String skuname) {
        this.skuname = skuname;
    }

    public String getModel() {
        return model;
    }

    public void setModel(String model) {
        this.model = model;
    }

    public String getDeliverydate() {
        return deliverydate;
    }

    public void setDeliverydate(String deliverydate) {
        this.deliverydate = deliverydate;
    }

    public String getUnit() {
        return unit;
    }

    public void setUnit(String unit) {
        this.unit = unit;
    }

    public String getZt() {
        return zt;
    }

    public void setZt(String zt) {
        this.zt = zt;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public String getBrand() {
        return brand;
    }

    public void setBrand(String brand) {
        this.brand = brand;
    }

    public String getBranden() {
        return branden;
    }

    public void setBranden(String branden) {
        this.branden = branden;
    }

    public String getCate1() {
        return cate1;
    }

    public void setCate1(String cate1) {
        this.cate1 = cate1;
    }

    public String getCate2() {
        return cate2;
    }

    public void setCate2(String cate2) {
        this.cate2 = cate2;
    }

    public String getCate3() {
        return cate3;
    }

    public void setCate3(String cate3) {
        this.cate3 = cate3;
    }

    public String getCate4() {
        return cate4;
    }

    public void setCate4(String cate4) {
        this.cate4 = cate4;
    }

    public String getAttrs() {
        return attrs;
    }

    public void setAttrs(String attrs) {
        this.attrs = attrs;
    }

    public String getCid1() {
        return cid1;
    }

    public void setCid1(String cid1) {
        this.cid1 = cid1;
    }

    public String getCidName1() {
        return cidName1;
    }

    public void setCidName1(String cidName1) {
        this.cidName1 = cidName1;
    }

    public String getBrandid() {
        return brandid;
    }

    public void setBrandid(String brandid) {
        this.brandid = brandid;
    }

    public String getBrandName() {
        return brandName;
    }

    public void setBrandName(String brandName) {
        this.brandName = brandName;
    }

    public String getMarketPrice() {
        return marketPrice;
    }

    public void setMarketPrice(String marketPrice) {
        this.marketPrice = marketPrice;
    }

    public String getPurchasePrice() {
        return purchasePrice;
    }

    public void setPurchasePrice(String purchasePrice) {
        this.purchasePrice = purchasePrice;
    }

    public String getMemberPrice() {
        return memberPrice;
    }

    public void setMemberPrice(String memberPrice) {
        this.memberPrice = memberPrice;
    }

    public String getWeight() {
        return weight;
    }

    public void setWeight(String weight) {
        this.weight = weight;
    }

    public String getLength() {
        return length;
    }

    public void setLength(String length) {
        this.length = length;
    }

    public String getWidth() {
        return width;
    }

    public void setWidth(String width) {
        this.width = width;
    }

    public String getHeight() {
        return height;
    }

    public void setHeight(String height) {
        this.height = height;
    }

    public String getItemNum() {
        return itemNum;
    }

    public void setItemNum(String itemNum) {
        this.itemNum = itemNum;
    }

    public String getDim1Val() {
        return dim1Val;
    }

    public void setDim1Val(String dim1Val) {
        this.dim1Val = dim1Val;
    }

    public String getDim1Sort() {
        return dim1Sort;
    }

    public void setDim1Sort(String dim1Sort) {
        this.dim1Sort = dim1Sort;
    }

    public String getDim2Val() {
        return dim2Val;
    }

    public void setDim2Val(String dim2Val) {
        this.dim2Val = dim2Val;
    }

    public String getDim2Sort() {
        return dim2Sort;
    }

    public void setDim2Sort(String dim2Sort) {
        this.dim2Sort = dim2Sort;
    }

    public String getPrice() {
        return price;
    }

    public void setPrice(String price) {
        this.price = price;
    }

    public String getEnable() {
        return enable;
    }

    public void setEnable(String enable) {
        this.enable = enable;
    }

    public Date getPushtime() {
        return pushtime;
    }

    public void setPushtime(Date pushtime) {
        this.pushtime = pushtime;
    }

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;
    }

    public String getApplyid() {
        return applyid;
    }

    public void setApplyid(String applyid) {
        this.applyid = applyid;
    }

    public String getOriginalPlace() {
        return originalPlace;
    }

    public void setOriginalPlace(String originalPlace) {
        this.originalPlace = originalPlace;
    }

    public String getWarranty() {
        return warranty;
    }

    public void setWarranty(String warranty) {
        this.warranty = warranty;
    }

    public static void main(String[] args) throws Exception {
        createTable(VCShelvesItem.class);
    }

}
